package com.vlh.battleship.server.integration.dao;

public class Sql {

	public final static String getGames = "select id, start_date, status, challenger, challenged, winner, turn from game";
	public final static String getTilesForGame = "select game_id, x, y, type, status, picture_id from tile where game_id = :game_id";
	public final static String getTiles = "select game_id, x, y, type, status, picture_id from tile";
	public final static String updateTile = "update tile set type = :type, status = :status, picture_id = :picture_id " +
			"where game_id = :game_id and x = :x and y = :y";
}
